Date Difference

The Date difference node is used for date manipulation to calculate the difference between two dates. The specified dates could be either an existing date column, a static date (for example 1 June 2016), or a user-defined variable. The date unit calculated can be a year, quarter, month, week, day, hour, minute, second, or millisecond.

Calculate Date Differences

Start by connecting the Date Difference node to a table containing a date-time column, or to an Add Date/ Time node. Go to the Properties panel to configure the node:

• Resulting Table Name: edit the table name if required
• From Date: Select Column, Static, or Variable to define the data type to be used for the from date.
  • If Column is selected, select the Column Name from the drop down list of date columns.
  • If Static is selected, select the date and time from the calendar picker.
  • If Variable is selected, select the variable name from the drop down list of variables.
• To Date: Select Column, Static, or Variable to define the data type to be used for the to date.
  • If Column is selected, select the Column Name from the drop down list of date columns.
  • If Static is selected, select the date and time from the calendar picker.
  • If Variable is selected, select the variable name from the drop down list of variables.
• Date Diff Unit: Select the date unit to be used to calculate the date difference. The date unit calculated can be a year, quarter, month, week, day, hour, minute, second, or millisecond.
• New Column Name: name the new column.

Related information

Common Properties

There are a number of fields that are present in the Properties panel when you have any of the preceding nodes selected on the canvas. These fields include Result Properties, Column Selection, Set Variable Values, and Metadata.

• Click here for more details about the Common Properties